package org.nobody.mallb2c.mallsearch.service.impl;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.TypeReference;
import org.apache.lucene.search.join.ScoreMode;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.index.query.BoolQueryBuilder;
import org.elasticsearch.index.query.NestedQueryBuilder;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.index.query.RangeQueryBuilder;
import org.elasticsearch.search.SearchHit;
import org.elasticsearch.search.SearchHits;
import org.elasticsearch.search.aggregations.AggregationBuilders;
import org.elasticsearch.search.aggregations.bucket.nested.NestedAggregationBuilder;
import org.elasticsearch.search.aggregations.bucket.nested.ParsedNested;
import org.elasticsearch.search.aggregations.bucket.terms.ParsedLongTerms;
import org.elasticsearch.search.aggregations.bucket.terms.ParsedStringTerms;
import org.elasticsearch.search.aggregations.bucket.terms.TermsAggregationBuilder;
import org.elasticsearch.search.builder.SearchSourceBuilder;
import org.elasticsearch.search.fetch.subphase.highlight.HighlightBuilder;
import org.elasticsearch.search.fetch.subphase.highlight.HighlightField;
import org.elasticsearch.search.sort.SortOrder;
import org.nobody.common.to.es.SkuEsModel;
import org.nobody.common.utils.R;
import org.nobody.mallb2c.mallsearch.config.MallElasticSearchConfig;
import org.nobody.mallb2c.mallsearch.constant.EsConstant;
import org.nobody.mallb2c.mallsearch.feign.ProductFeignService;
import org.nobody.mallb2c.mallsearch.service.MallSearchService;
import org.nobody.mallb2c.mallsearch.vo.AttrResVo;
import org.nobody.mallb2c.mallsearch.vo.BrandVo;
import org.nobody.mallb2c.mallsearch.vo.SearchParam;
import org.nobody.mallb2c.mallsearch.vo.SearchResult;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.StringUtils;

import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.List;
import java.util.stream.Collectors;

/**
 * @author 3489309323@qq.com
 * @create 2020-09-11-18:48
 */
@Service
public class MallSearchServiceImpl implements MallSearchService {
  @Autowired
  private RestHighLevelClient client;

  @Autowired
  ProductFeignService productFeignService;

  @Override
  public SearchResult search(SearchParam param) {
    SearchResult result = null;

    //1、 准备检索请求
    SearchRequest searchRequest = buildSearchRequest(param);

    try {
      //2、 执行检索请求
      SearchResponse response = client.search(searchRequest, MallElasticSearchConfig.COMMON_OPTIONS);

      //3、 分析响应数据封装成我们需要的格式
      result = buildSearchResult(response, param);
    } catch (IOException e) {
      e.printStackTrace();
    }
    return result;
  }

  /**
   * 准备检索请求
   *
   * @param param
   * @return
   */
  private SearchRequest buildSearchRequest(SearchParam param) {
    SearchSourceBuilder sourceBuilder = new SearchSourceBuilder(); //构建DSL语句

    // 1 模糊匹配、过滤(按照属性、分类、品牌、价格区间、库存)
    // 1.1、 构建bool - query
    BoolQueryBuilder boolQuery = QueryBuilders.boolQuery();
    sourceBuilder.query(boolQuery);
    // must match - 模糊匹配
    if (!StringUtils.isEmpty(param.getKeyword())) {
      boolQuery.must(QueryBuilders.matchQuery("skuTitle", param.getKeyword()));
    }
    //1.2、 filter
    // 按照三级分类id
    if (param.getCatalog3Id() != null) {
      boolQuery.filter(QueryBuilders.termQuery("catalogId", param.getCatalog3Id()));
    }
    // 按照品牌id
    if (param.getBrandId() != null && param.getBrandId().size() > 0) {
      boolQuery.filter(QueryBuilders.termsQuery("brandId", param.getBrandId()));
    }
    // 按照所有指定的属性(可检索规格参数)
    if (param.getAttrs() != null && param.getAttrs().size() > 0) {
      //1号属性 值有5寸 8寸
      //2号属性 值有16g 8g
      //attrs=1_5寸:8寸&attrs=2_16G:8G
      param.getAttrs().forEach(attrStr -> {
        BoolQueryBuilder nestedBoolQuery = QueryBuilders.boolQuery();

        String[] s = attrStr.split("_");
        String attrId = s[0];
        String[] attrValues = s[1].split(":"); //这个属性的检索用的值
        nestedBoolQuery.must(QueryBuilders.termQuery("attrs.attrId", attrId));
        nestedBoolQuery.must(QueryBuilders.termsQuery("attrs.attrValue", attrValues));

        NestedQueryBuilder nestedQuery = QueryBuilders.nestedQuery("attrs", nestedBoolQuery, ScoreMode.None/*?不参与评分 todo*/);
        boolQuery.filter(nestedQuery);
      });
    }
    // 按照库存
    if (param.getHasStock() != null) {
      boolQuery.filter(QueryBuilders.termQuery("hasStock", param.getHasStock() == 1));
    }
    // 按照价格区间
    if (!StringUtils.isEmpty(param.getSkuPrice())) {
      RangeQueryBuilder rangeQuery = QueryBuilders.rangeQuery("skuPrice");
      String[] s = param.getSkuPrice().split("_");
      if (s.length == 2) { //小于大于
        rangeQuery.gte(s[0]).lte(s[1]);
      } else if (s.length == 1) {
        if (param.getSkuPrice().startsWith("_")) { //小于
          rangeQuery.lte(s[0]);
        }
        if (param.getSkuPrice().endsWith("_")) { //大于
          rangeQuery.gte(s[0]);
        }
      }
      boolQuery.filter(rangeQuery);
    }

    // 2 排序非、分页、高亮
    // 2.1、 排序
    if (!StringUtils.isEmpty(param.getSort())) {
      String sort = param.getSort();
      String[] s = sort.split("_");
      SortOrder order = s[1].equalsIgnoreCase("asc") ? SortOrder.ASC : SortOrder.DESC;
      sourceBuilder.sort(s[0], order);
    }
    // 2.2、 分页
    //from = (pageNum-1)*size
    sourceBuilder.from((param.getPageNum() - 1) * EsConstant.PRODUCT_PAGESIZE);
    sourceBuilder.size(EsConstant.PRODUCT_PAGESIZE);
    // 2.3、 高亮
    if (!StringUtils.isEmpty(param.getKeyword())) {
      HighlightBuilder builder = new HighlightBuilder();
      builder.field("skuTitle");
      builder.preTags("<b style='color:red'>");
      builder.postTags("</b>");
      sourceBuilder.highlighter(builder);
    }

    // 3 聚合分析
    // 3.1、 品牌聚合
    TermsAggregationBuilder brand_agg = AggregationBuilders.terms("brand_agg").field("brandId").size(50);
    // 品牌聚合的子聚合(相当于连表查询)
    brand_agg.subAggregation(AggregationBuilders.terms("brand_name_agg").field("brandName").size(1));
    brand_agg.subAggregation(AggregationBuilders.terms("brand_img_agg").field("brandImg").size(1));
    sourceBuilder.aggregation(brand_agg);
    // 3.2、 分类聚合 catalog_agg
    TermsAggregationBuilder catalog_agg = AggregationBuilders.terms("catalog_agg").field("catalogId").size(20);
    // 分类聚合的子聚合(相当于连表查询)
    catalog_agg.subAggregation(AggregationBuilders.terms("catalog_name_agg").field("catalogName").size(1));
    sourceBuilder.aggregation(catalog_agg);
    // 3.3、 属性聚合
    NestedAggregationBuilder attr_agg = AggregationBuilders.nested("attr_agg", "attrs");
    TermsAggregationBuilder attr_id_agg = AggregationBuilders.terms("attr_id_agg").field("attrs.attrId");
    attr_id_agg.subAggregation(AggregationBuilders.terms("attr_name_agg").field("attrs.attrName").size(1)); //连表查到name
    attr_id_agg.subAggregation(AggregationBuilders.terms("attr_value_agg").field("attrs.attrValue").size(50)); //一个筛选属性会有多个值
    attr_agg.subAggregation(attr_id_agg);
    sourceBuilder.aggregation(attr_agg);


    System.out.println("构建的DSL：" + sourceBuilder.toString());
    SearchRequest searchRequest = new SearchRequest(
      new String[]{EsConstant.PRODUCT_INDEX}/*← ["product"]*/,
      sourceBuilder
    );

    return searchRequest;
  }

  /**
   * 构建结果数据
   *
   * @param response
   * @param param
   * @return
   */
  private SearchResult buildSearchResult(SearchResponse response, SearchParam param) {
    SearchResult result = new SearchResult();
    //1、 返回的所有查询到的商品
    SearchHits hits = response.getHits();
    List<SkuEsModel> esModels = new ArrayList<>();
    if (hits.getHits() != null && hits.getHits().length > 0) {
      for (SearchHit hit : hits.getHits()) {
        String sourceAsString = hit.getSourceAsString();
        SkuEsModel esModel = JSON.parseObject(sourceAsString, SkuEsModel.class);
        if (!StringUtils.isEmpty(param.getKeyword())) { //参数带了keyword字段 说明要全文检索skuTitle 并且高亮显示 我们这里需要把highlight里es帮我们生成的高亮文本设置到返回模型中
          HighlightField skuTitle = hit.getHighlightFields().get("skuTitle");
          String string = skuTitle.getFragments()[0].string();
          esModel.setSkuTitle(string);
        }
        esModels.add(esModel);
      }
    }
    result.setProducts(esModels);

    //2、 当前所有商品涉及到的属性信息
    ParsedNested attr_agg = response.getAggregations().get("attr_agg");
    List<SearchResult.AttrVo> attrVos = new ArrayList<>();
    ParsedLongTerms attr_id_agg = attr_agg.getAggregations().get("attr_id_agg");
    attr_id_agg.getBuckets().forEach(bucket -> {
      SearchResult.AttrVo attrVo = new SearchResult.AttrVo();
      //2.1、 得到属性id
      long attrId = bucket.getKeyAsNumber().longValue();
      //2.2、 得到属性名字
      String attrName = ((ParsedStringTerms) bucket.getAggregations().get("attr_name_agg")).getBuckets().get(0).getKeyAsString();
      //2.3、 得到属性所有值
      List<String> attrValues = ((ParsedStringTerms) bucket.getAggregations().get("attr_value_agg")).getBuckets().stream().map(item -> {
        String keyAsString = item.getKeyAsString();
        return keyAsString;
      }).collect(Collectors.toList());
      attrVo.setAttrId(attrId);
      attrVo.setAttrName(attrName);
      attrVo.setAttrValue(attrValues);

      attrVos.add(attrVo);
    });
    result.setAttrs(attrVos);

    //3、 当前所有商品涉及到的品牌信息
    ParsedLongTerms brand_agg = response.getAggregations().get("brand_agg");
    List<SearchResult.BrandVo> brandVos = new ArrayList<>();
    brand_agg.getBuckets().forEach(bucket->{
      SearchResult.BrandVo brandVo = new SearchResult.BrandVo();
      //3.1、 得到品牌的id
      long brandId = bucket.getKeyAsNumber().longValue();
      //3.2、 得到品牌的名字
      String brandName = ((ParsedStringTerms) bucket.getAggregations().get("brand_name_agg")).getBuckets().get(0).getKeyAsString();
      //3.3、 得到品牌的图片
      String brandImg = ((ParsedStringTerms) bucket.getAggregations().get("brand_img_agg")).getBuckets().get(0).getKeyAsString();
      brandVo.setBrandId(brandId);
      brandVo.setBrandImg(brandImg);
      brandVo.setBrandName(brandName);
      brandVos.add(brandVo);
    });
    result.setBrands(brandVos);

    //4、 当前所有商品涉及到的分类信息
    ParsedLongTerms catalog_agg = response.getAggregations().get("catalog_agg");
    List<SearchResult.CatalogVo> catalogVos = new ArrayList<>();
    catalog_agg.getBuckets().forEach(bucket->{
      SearchResult.CatalogVo catalogVo = new SearchResult.CatalogVo();
      //得到分类id
      String keyAsString = bucket.getKeyAsString();
      catalogVo.setCatalogId(Long.parseLong(keyAsString));
      //得到分类名
      ParsedStringTerms catalog_name_age = bucket.getAggregations().get("catalog_name_agg");
      String catalog_name = catalog_name_age.getBuckets().get(0).getKeyAsString();
      catalogVo.setCatalogName(catalog_name);
      catalogVos.add(catalogVo);
    });
    result.setCatalogs(catalogVos);

    //=== 以上从聚合信息可以获取到 ===

    //5、 分页相关信息
    result.setPageNum(param.getPageNum());
    long total = hits.getTotalHits().value;
    result.setTotal(total);
    int totalPages = (int) (total / EsConstant.PRODUCT_PAGESIZE == 0 ? total / EsConstant.PRODUCT_PAGESIZE : (total / EsConstant.PRODUCT_PAGESIZE + 1));
    result.setTotalPages(totalPages);

    List<Integer> pageNavs = new ArrayList<>();
    for (int i =1; i <= totalPages; i++) {
      pageNavs.add(i);
    }
    result.setPageNavs(pageNavs);

    //6、 构建条件筛选面包屑导航
    //todo ....这里循环发送请求是要不得的,另外明明es里有,干嘛查数据库....
    //todo
    //6.1
    if (param.getAttrs() != null && param.getAttrs().size()>0) {
      List<SearchResult.NavVo> navVos = param.getAttrs().stream().map(attr -> {
        SearchResult.NavVo navVo = new SearchResult.NavVo();
        //attrs=2_5存:6存
        String[] s = attr.split("_");
        navVo.setNavValue(s[1]);
        R r = productFeignService.attrInfo(Long.parseLong(s[0]));
        result.getAttrIds().add(Long.parseLong(s[0]));
        if (r.getCode() == 0) {
          AttrResVo data = r.getData("attr", new TypeReference<AttrResVo>() {});
          navVo.setNavName(data.getAttrName());
        }else{
          navVo.setNavName(s[0]);
        }
        //2、 取消了这个面包屑以后,要跳转到哪个地方,就将请求地址的url里面的当前置空
        //前端传来的url会被编码,我们这里把编码后的attr替换为空
        String replace = replaceQueryString(param, attr, "attrs");
        navVo.setLink("http://search.mall.com/list.html?" + replace);

        return navVo;
      }).collect(Collectors.toList());

      result.setNavs(navVos);
    }

    //6.2 品牌、分类
    //todo 点击品牌 生成的面包屑中 品牌没有正确显示值(为null)
    if (param.getBrandId() != null && param.getBrandId().size() > 0) {
      List<SearchResult.NavVo> navs = result.getNavs();
      SearchResult.NavVo navVo = new SearchResult.NavVo();
      navVo.setNavName("品牌");
      R r = productFeignService.brandsInfo(param.getBrandId());
      if (r.getCode() == 0) {
        List<BrandVo> brands = r.getData("brand", new TypeReference<List<BrandVo>>() {});
        StringBuffer buffer = new StringBuffer();
        String replace = "";
        for (BrandVo brandVo : brands) {
          buffer.append(brandVo.getBrandName()+";");
          //todo emmm 这里替换逻辑貌似有问题
          replace = replaceQueryString(param, brandVo.getBrandId()+"", "brandId");
        }
        navVo.setNavValue(buffer.toString());
        navVo.setLink("http://search.mall.com/list.html?" + replace);
      }
      navs.add(navVo);
    }
    //todo 分类 分类不需要导航取消

    return result;
  }

  private String replaceQueryString(SearchParam param, String value, String key) {
    String encode = null;
    try {
      encode = URLEncoder.encode(value, "UTF-8");
      encode = encode.replace("+", "%20"); //注意java里空格会被翻译为`+`,但浏览器编译为`%20`
      encode = encode.replace("%28","("); //emmm 不知道为嘛前端传来的(是没有被转译的
      encode = encode.replace("%29",")");
    } catch (UnsupportedEncodingException e) {
      e.printStackTrace();
    }
    //System.out.println(param.get_queryString()); //attrs=8_%E6%B5%B7%E6%80%9D(HiSilicon)&attrs=9_HUAWEI%20Kirin970
    return param.get_queryString().replace("&" + key + "=" + encode, "");
  }

}
